---
title: TableObject.PreserveFormatting Property (Excel)
keywords: vbaxl10.chm916083
f1_keywords:
- vbaxl10.chm916083
ms.prod: excel
ms.assetid: 1557f95d-3fef-52ae-750c-02370a10cfd2
ms.date: 06/08/2017
---


# TableObject.PreserveFormatting Property (Excel)

 **True** if any formatting common to the first five rows of data are applied to new rows of data in the query table. Unused cells aren't formatted. The property is **False** if the last AutoFormat applied to the query table is applied to new rows of data. The default value is **True** . **Boolean** Read/Write


## Syntax

 _expression_ . **PreserveFormatting**

 _expression_ A variable that represents a[TableObject](modeltable-object-excel.md)object.


## Property value

 **BOOL**


## See also


#### Other resources



[TableObject Object](modeltable-object-excel.md)

